The Oracle REMOTE_OS_ROLES parameter must be set to FALSE.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-219831	O121-BP-022000	SV-219831r903017_rule		High

Description
Setting REMOTE_OS_ROLES to TRUE allows operating system groups to control Oracle roles. The default value of FALSE causes roles to be identified and managed by the database. If REMOTE_OS_ROLES is set to TRUE, a remote user could impersonate another operating system user over a network connection.

STIG	Date
Oracle Database 12c Security Technical Implementation Guide	2023-06-01

Details

Check Text ( C-21542r903016_chk )
From SQL*Plus: select value from v$parameter where name = 'remote_os_roles'; If the value returned is FALSE, this is not a finding. If the value returned is TRUE, confirm that the setting is justified and documented. If not, this is a finding.

Fix Text (F-21541r533033_fix)
Document remote OS roles in the System Security Plan. If not required, disable use of remote OS roles. From SQL*Plus: alter system set remote_os_roles = FALSE scope = spfile; The above SQL*Plus command will set the parameter to take effect at next system startup.